SELECT events.*, eventToShluchaAndDate.* FROM events
LEFT JOIN eventToShluchaAndDate ON events.eventID = eventToShluchaAndDate.eventToShluchEventID
WHERE events.mercazAllId=67 AND eventID=21167
AND eventToShluchFromTime != '00:00:00' AND eventToShluchToTime != '00:00:00'